package com.scoresystem.dao;

import java.util.List;

import com.scoresystem.model.Score;
import com.scoresystem.model.StuScore;

/**
 * 
 * @author Administrator
 *操纵成绩单的数据库访问类
 */
public interface IScoreDao {
	/**
	 * 列出所有成绩表
	 * @param stuclass 学生班级
	 * @param couresename 课程
	 * @param workname 评分人
	 * @return
	 */
	public List<StuScore> listAll(String stuclass,String couresename,String workname);
	/**
	 * 批量录入用户
	 * @param stuclass
	 * @param coursename
	 * @param worknum
	 * @param stunum
	 * @param score
	 * @return
	 */
	public boolean insertScores(String stuclass,String coursename,
			String worknum,String[] stunum,String[] score,String []stuname);
	 /**
	  * 单个录入
	  * @param stuclass
	  * @param couresename
	  * @param worknum
	  * @param stunum
	  * @param score
	  * @param stuname
	  * @return
	  */
	public boolean insertScore(String stuclass,String couresename,String worknum,
			String stunum,String score,String stuname);
	/**
	 * 根据学生姓名和课程查询成绩
	 * @param stuclass
	 * @param coursename
	 * @return
	 */
	public String getScorebyClassCourse(String stunum,String stuclass,String coursename);
	/**
	 * 根据学号查各科成绩
	 * @param stunum
	 * @return
	 */
	public List<Score> listscores(String stunum);
	/**
	 * 教师修改成绩
	 * @param stuclass
	 * @param coursename
	 * @param worknum
	 * @param stunum
	 * @param score
	 * @param stuname
	 * @return
	 */
	public boolean modify(String stuclass,String coursename,
			String worknum,String stunum,String score);
	
	
}
